---
title: "sp73089_get_policy_bound_flag stored procedure documentation"
summary: "Retrieved Oracle wrapper function that returns a `Y` or `N` flag for application-policy bound status."
status: draft
owner: "SAIF Claims BOF team"
last_reviewed: "2026-08-25"
source_schema: "WCIS_DBA"
source_name: "sp73089_get_policy_bound_flag"
source_type: "FUNCTION"
retrieval_status: "found"
retrieval_command: "legends oracle query --name sp73089_get_policy_bound_flag"
retrieval_date: "2026-08-25"
---
# sp73089_get_policy_bound_flag

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Standalone function |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.View.Policy` |
| **Calling classes** | `clsPolicyData` |

## Purpose

`sp73089_get_policy_bound_flag` wraps the Boolean `sp72325_chk_if_policy_bound` function so View Policy can consume a `Y` or `N` indicator for application policies.

## Procedures / Methods

### sp73089_get_policy_bound_flag

| Field | Value |
| --- | --- |
| **Returns** | `VARCHAR2` |
| **Called by** | `clsPolicyData` ad hoc retrieval |
| **Description** | Returns `Y` when the supplied application policy period is bound; otherwise returns `N`. |

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number to evaluate. |
| `in_policy_period_eff_date` | IN | `DATE` | — | Policy-period effective date to evaluate. |

## Business Rules

The retrieved database source embeds the following server-side rules.

| Rule ID | Summary |
| --- | --- |
| [BR-VP-034](#br-vp-034-bound-policy-status-is-returned-as-y-or-n) | The wrapper converts `sp72325_chk_if_policy_bound(...)` Boolean output into `Y` or `N`. |

### BR-VP-034 Bound-policy status is returned as Y or N

| Field | Value |
| --- | --- |
| **Statement** | The function returns `Y` when `sp72325_chk_if_policy_bound(in_policy_num, in_policy_period_eff_date)` is true and `N` otherwise. |
| **Trigger** | `sp73089_get_policy_bound_flag` executes. |
| **Enforcement** | The function sets `flag := 'Y'` or `N` based on the wrapped Boolean function and returns `flag`. |
| **Outcome** | Callers receive a character flag instead of a PL/SQL Boolean. |
| **Source** | Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp73089_get_policy_bound_flag.json` |

## Operations

The retrieved database source implements the following internal operations.

| Operation | Description | Trigger |
| --- | --- | --- |
| [Convert policy-bound Boolean result to a character flag](#convert-policy-bound-boolean-result-to-a-character-flag) | Call the wrapped Boolean function and return `Y` when the policy is bound or `N` when it is not. | Caller invokes `sp73089_get_policy_bound_flag`. |

### Convert policy-bound Boolean result to a character flag

| Field | Value |
| --- | --- |
| **Description** | Call the wrapped Boolean function and return `Y` when the policy is bound or `N` when it is not. |
| **Trigger** | Caller invokes `sp73089_get_policy_bound_flag`. |
| **Source** | Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp73089_get_policy_bound_flag.json` |

## Calling code references

| Class | Method | Source File |
| --- | --- | --- |
| `clsPolicyData` | `ad hoc method` | `SAIF.Business.View.Policy\clsPolicyData.vb` |

## Source Code

<details>
<summary>PL/SQL function source</summary>

```sql
FUNCTION sp73089_get_policy_bound_flag (
/****************************************************************
*Procedure Title  : This is a wrapper function to return a 'Y'' or 'N' flag
*                   for policies in APP status. The function wraps the boolean
*					function sp72325_chk_if_policy_bound
*Name             : sp73089_get_policy_bound_flag
*Called by        : Business Online - ViewPolicy Summary page
*****************************************************************
*PROGRAMMER     ANALYST                 DATE        MOD #
*JERTOD        						 02/06/2007
*Description:	This procedure will check if the policy has bound
*               coverage.
* Maintenance Log:
*   Release         Name    Date      Description
******************************************************************/
        in_policy_num              IN  NUMBER,
        in_policy_period_eff_date  IN  DATE)

    RETURN VARCHAR2

IS

flag					   varchar2(1);

BEGIN

IF sp72325_chk_if_policy_bound(in_policy_num,in_policy_period_eff_date) THEN
   flag:='Y';
ELSE
	flag:='N';
END IF;

RETURN flag;

END; -- sp73089_get_policy_bound_flag
```

</details>

## Related documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

## Sources
- Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp73089_get_policy_bound_flag.json`
- Calling code: `SAIF.Business.View.Policy\clsPolicyData.vb`